Search first letter

[Anon]

Is there any good way to do a query on mysql table, but only grabbing the rows where the first letter is x? (x meaning it could be anything) ?

The onlyway i could see doing this is grabbing every row, and doing a substr($str, 0, 1) and if its x then display it. But is there a bettery way? I dont want to go through thousands of records...

Derek C.

[Anon]

Just an idea would this work?

SELECT whatever FROM table WHERE field like 'x%'

??

Derek C.

[non_zero]

I...don't see why not.

[mickro]

Or you could use

SELECT * FROM table WHERE SUBSTRING(field,1,1) = 'x'

don't know whether there is any advantage to this over the way you have done it though??

Mike

[tangnes]

As long as you have en index on the field in question, it should not make unnessesary searches!

(MySQL🙂
create table vare (
varenummer CHAR(20) not null,
primary key (varenummer),
INDEX ivare(varenummer));