On 09 Dec 2005 10:45:04 +0800, Jeffrey G. Ubalde
I have been thinking about this for hours, and I cant quite get the
correct keyword for me to search it in the manual.
for example i have a field that contains string1:string2:string3
where colon ':' is the delimiter.
How do i create a select
I'm running this query to get a count of categories I have in a field that contains
aircraft categories.
SELECT substring(category,10), count(*)
FROM `links` where category like 'Aircraft/Sales%'
group by category order by category
and getting these results:
---