At 9:20 AM +0300 9/27/01, Jari Mäkelä wrote:
>Hi,
>
>Is it possible to search with LIKE for a field name? I have database
>that has various data and the field names are named by the language
>it is aimed for.
>
>So can MySQL be used to search that field list for all fields having
>specific string in them and then selecting all data pertinent to the
>found fields?
You can't do it in pure SQL. You could write a program that does
SHOW TABLES
to get the table names, then
SHOW COLUMNS FROM tbl_name
to get the column names for each table. From that you can derive the
column names you want to search.
>
>jari Mäkelä
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread86474@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Paul DuBois, paul@stripped
