[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

IN(INT VS CHAR)


When using IN should i design the database to use int's or is the performance 
equal?

WHERE col IN('test','test2','test3')
vs
WHERE col IN(1,2,3)
 

-------------------------------------------------
FREE E-MAIL IN 1 MINUTE!
 - suppressed - http://www.pc.nu

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.