Re: SET column type??

2004-04-27 Thread Jigal van Hemert
i am sort of confused about the SET column type... is there any place that i can go that will give a better example of it and how to use/create it than the manual does?? If you read the user comments on the manual page (http://dev.mysql.com/doc/mysql/en/SET.html) you'll see loads of examples

SET column type??

2004-04-26 Thread Andy B
hi.. i am sort of confused about the SET column type... is there any place that i can go that will give a better example of it and how to use/create it than the manual does?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Efficiency of SET column type queries

2002-12-02 Thread speters
I've bene trying to find info on how efficient queries are for the SET datatype, specifically, how does MySQL use indexes for SET column types. I have looked in the O'Reilly MySQL Reference Manual, and at mysql.com and have found effectively nothing on this subject. For example, if i have a table

Re: Does FIND_IN_SET() require SET column type?

2002-08-25 Thread Benjamin Pflugmann
there). You can easily test for yourself by trying SELECT FIND_IN_SET( 1, -5,0,1,4,5, ) that it not even requires a column. The thing is, I cannot make it set column-type, since I have no idea what values it will be holding, but at the same time it will be comma seperated list of integers. So I'll