Have a look at fulltext searches. This is described in the MySQL manual at
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html. If you put all of your columns
in the column list following the FULLTEXT keyword, you will be able to use MATCH
AGAINST expressions to find what you want.
I'm assuming that all of the columns you are searching are character columns; I don't
think you can put numeric or date/time columns in the FULLTEXT column list, although I
have never tried it so I may be wrong.
Rhino
----- Original Message -----
From: Gokce Hazaroglu
To: [EMAIL PROTECTED]
Sent: Thursday, October 14, 2004 12:42 PM
Subject: Hi, a problem about selecting...
I've a table and many fields. I want to search something in all fields.
-> select * from table where table.* like '%something%' did not work.. Is
there a way to do this?
Gokce AKKAYA HAZAROGLU
OptikNet Bilgisayar
[EMAIL PROTECTED]
http://www.optiknet.com.tr
