Mysql order by first letter of name

[Cyto]

Hi,

 

Is it possible to order by the first letter of name?

Data is coming from a post value.

$qorder = substr($q,0,1);
SELECT * FROM data WHERE name LIKE '%$q%' OR info LIKE '%$q%'
Want something like this: ORDER BY name='$qorder%', but doesnt work

 

Thx,

[Pandemikk]

ORDER BY ASC

[sunfighter]

ORDER BY "column_name" [ASC, DESC]

[Cyto]

I mean order by the value from post, so when the value is Santa. I want to order by S of Santa.

[xyph]

SELECT `columns` FROM `table` WHERE `column` LIKE 's%'

[Cyto]

SELECT `columns` FROM `table` WHERE `column` LIKE 's%'

--- nvm ---

Thx LIKE '$q%' works.