Hi,
I don't think it is possible with out specifing the field names.
But we can get the soultion in the following way
If we have tabel calles 'test' with fields namely field1 and field2 then
you can get all the records that conatin 'c' with the following query
select * from test where Field1 like '%c%' or Field2 like '%c%'
Will this solve your problem?
Regards,
Sneha
At 01:32 PM 10/5/01 +0300, Ladopoulos Theodoros wrote:
>hello,
>
>I would like to ask if it is possible with mysql to do soomething like this:
>
>SELECT * FROM [specific table name] WHERE [WHATEVER FIELD(not specified)]
>LIKE '%sometext%'
>
>Is there a variable lets say to refer to the column name?
>
>What I actually want to do is to find all records that fields of a specific
>value without specifing the field name. To search for a string in a table
>but not say in what field (search in all fields)
>
>i want to know if that can be done with a single query.
>
>thanks a lot in advance
>
>teo
>[EMAIL PROTECTED]
>
>
>---------------------------------------------------------------------
>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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
