Re: select * where [whatever column] LIKE '%something%'

2001-10-05 Thread Ladopoulos Theodoros
yes that gives the right results but i ask if i can do the same thing without enumerating all fields like this: SELECT * FROM [tablename] WHERE Field1 LIKE '%text%' OR Field2 LIKE '%text%' OR ... What i want is to do the same thing without knowing what are the field names or how many fields thi

select * where [whatever column] LIKE '%something%'

2001-10-05 Thread Ladopoulos Theodoros
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 field