fenway

You could use a trigger....

Hard to say... that's a dependent subquery -- only run once for the outer query -- and obviously the DISTINCT would make that subquery take longer. However, NOT IN() would have to check a longer list without the DISTINCT. They're both bad.

Not sure.. though in this case you don't really need an BEGIN/END block at all.

Actually, it is... unless it's inside COUNT().

Sigh... run this: SELECT cast(left(itemNumber+ '-0', instr(itemNumber+ '-0', '-')) as unsigned) as part1, cast(mid(itemNumber+ '-0', instr(itemNumber+ '-0', '-')+1) as unsigned) as part2, * FROM tblPlantilla

Amend how?

Missing quotes for those format specifiers.

Why INOUT? It should probably be just IN.

What do you mean by that, sir? I mean I'd like to see what those expression return.

Could you include each of those expressions in the column list?

No, your question revolves around a database query... but therein lies your actual problem. If you don't know how to use the tool you've chosen for the job to implement the solution, then you've wasted my time, not vice versa. But hey, by all means, wait for someone else's help -- you will receive no more from me.

I have no idea what dreamweaver automatically does. You need some control loops to handle this.

Huh?

Not that I can think of... but there are some stickies that will help guide you.

Huh?

You could search with a UNION... you'll just have to alias the first column name.

Can't be that automatic... though a left join could find them esaily.

You have 2 conditions: #1: WHERE state = '$state' #2: WHERE state = '$state' AND city = '$city' SQL can't decide when do #1 vs #2 -- you need php application code to do this. I don't know what part of this is "difficult".

You can change the sql mode for a given connection.

Sounds reasonable... to be honest, I've never made it smaller, only larger.

You *don't* want it to search both fields... you want it to search state always, and city sometimes.

You can't limit on a join... you'd have to create a derived table with this artificial limit, then join it back.

I sure can fulltext across multiple tables I may need to use multiple queries but it can be done It can't be done without multiple queries... but that's not going to "use" an index.

You can't check count in the where clause.... that subquery should be SELECT `Tag` FROM `Tags` WHERE `Tag` = `user_tag` GROUP BY `Tags`.`Tag HAVING COUNT( `Tags`.`Tag` ) > 2

You need to handle this in your php code first... figure out which fields are present, then build your where clause accordingly.