Noob SQL question. SQL Patterns
Posted: Thu Oct 30, 2008 6:38 am
g'day,
i KNOW this will sound horrid to some, but i cant get it. please help.
I'm trying to query my DB, while looking for items that start with a particular character... say 3.
i've tried
[/color]
none of which work. Obviously.
Can some1 please help?
i KNOW this will sound horrid to some, but i cant get it. please help.
I'm trying to query my DB, while looking for items that start with a particular character... say 3.
i've tried
Code: Select all
SELECT * FROM `movie_database`.`movie_list`WHERE `Title` LIKE '3'
SELECT * FROM `movie_database`.`movie_list`WHERE `Title` LIKE '^3'
SELECT * FROM `movie_database`.`movie_list`WHERE `Title` LIKE '^(3)'
none of which work. Obviously.
Can some1 please help?