Arranging by Letter?

[_OwNeD.YoU_]

Hi guys again,

trying query only for the letter k, but its not the first letter cant figure these wildcards out.

 

 

UCUS-98646 Killzone Liberation [uS]

 

the k for killzone

 

 

 

[revraz]

Use the LIKE parameter

 

LIKE '%k%'

LIKE 'k%'

LIKE '%k'

 

Your choice on how you want to do it.

[_OwNeD.YoU_]

yea but

 

UCUS-98646 Killzone Liberation [uS]

 

if there was any K in the title i wouldnt work right, it would grab any with k's

[revraz]

Huh?

 

If you are looking to only grab what is after UCUS-98646 as the start of your search, then you need to use RegEx.  I assume your title is the entire line you posted?

 

Is the format always the same?

[premiso]

What exactly are you trying to do?

 

If this is in a database, why not put UCUS-98646 Killzone Liberation [uS] into 3 seperate fields?

 

IE:

UCUS-98646 in a field called "code"

Killzone Liberation in a field called "title"

US in a field called "country"

 

That will save you tremendous heartache of parsing etc and will allow for easy searchability etc. And you can easily rebuild the string to look like it does above.

[_OwNeD.YoU_]

$text = $data[title];

  if(preg_match('/^([^\s]+)\s+(.+)\s+\[(..)\]$/',$text,$matches)){

    list(,$code,$title,$country) = $matches;

 

did that but how would i just show all $title begining with the letter k

 

Huh?

 

If you are looking to only grab what is after UCUS-98646 as the start of your search, then you need to use RegEx.  I assume your title is the entire line you posted?

 

Is the format always the same?

format is the entire line, format is also always the same

[_OwNeD.YoU_]

If you are looking to only grab what is after UCUS-98646 as the start of your search, then you need to use RegEx.  I assume your title is the entire line you posted?

yes and im looking to arrange with the first letter after the UCUS-98646

[sasa]

try

SELECT * 
FROM  `proba` 
WHERE SUBSTRING( name, LOCATE(  ' ', name ) +1 ) LIKE  'K%'