Im trying to do a select statement that querys my comments column for all data that includes @"username" in a database table. For example if i wanted to find @bobby. The query would search for wildcard @ in combination with checking each element in the username column. e.g username column is
**USERNAME**
bobby
foo
patrick
This is what I have so far ( I know its wrong but you get the idea what I am trying to achieve )
"SELECT * FROM posts WHERE content LIKE '%@%' AND content LIKE "entire usename column""
Aucun commentaire:
Enregistrer un commentaire