Select * from Table where ....

['LinKin]

Hello,

I want to select the rows from a certain table that contain a string in one of its columns.

More explained:

Serial___________Nicknames

182739817298____Link, test, stuff, bla

180009817298____asd, zaa, dada, zimbe

180000017298____ee, , hh, bla

How can I select the rows that contain "bla" in the Nicknames column?

I'm using MySQL, and the Nicknames column is type TEXT

Thanks

[arezu]

MTA example:

local name = "bla" 
dbQuery(connection, "SELECT * FROM Table WHERE Nicknames = ?", name) 

or do you mean when the column "Nicknames" contains "bla" somewhere, where nicknames are seperated by a comma?

['LinKin]

Yes, I mean that Arezu..

Just like string.find

['LinKin]

local theQuery = dbPoll(dbQuery(dbHandler, "SELECT * FROM `myTable` WHERE `nicknames` LIKE ?", "%"..theArg.."%"), -1) 

Solved the thing.

Now, should I use a fulltext index in the 'nicknames' column? To make queries be faster