03 Jul 08 Radosna twórczość “programisty”
Na coś takiego natrafiłem:
SELECT id FROM user WHERE ((gender=’F’ OR gender=’M') AND (age LIKE ‘%1926%’ OR age LIKE ‘%1927%’ OR age LIKE ‘%1928%’ OR age LIKE ‘%1929%’ OR age LIKE ‘%1930%’ OR age LIKE ‘%1931%’ OR age LIKE ‘%1932%’ OR age LIKE ‘%1933%’ OR age LIKE ‘%1934%’ OR age LIKE ‘%1935%’ OR age LIKE ‘%1936%’ OR age LIKE ‘%1937%’ OR age LIKE ‘%1938%’ OR age LIKE ‘%1939%’ OR age LIKE ‘%1940%’ OR age LIKE ‘%1941%’ OR age LIKE ‘%1942%’ OR age LIKE ‘%1943%’ OR age LIKE ‘%1944%’ OR age LIKE ‘%1945%’ OR age LIKE ‘%1946%’ OR age LIKE ‘%1947%’ OR age LIKE ‘%1948%’ OR age LIKE ‘%1949%’ OR age LIKE ‘%1950%’ OR age LIKE ‘%1951%’ OR age LIKE ‘%1952%’ OR age LIKE ‘%1953%’ OR age LIKE ‘%1954%’ OR age LIKE ‘%1955%’ OR age LIKE ‘%1956%’ OR age LIKE ‘%1957%’ OR age LIKE ‘%1958%’ OR age LIKE ‘%1959%’ OR age LIKE ‘%1960%’ OR age LIKE ‘%1961%’ OR age LIKE ‘%1962%’ OR age LIKE ‘%1963%’ OR age LIKE ‘%1964%’ OR age LIKE ‘%1965%’ OR age LIKE ‘%1966%’ OR age LIKE ‘%1967%’ OR age LIKE ‘%1968%’ OR age LIKE ‘%1969%’ OR age LIKE ‘%1970%’ OR age LIKE ‘%1971%’ OR age LIKE ‘%1972%’ OR age LIKE ‘%1973%’ OR age LIKE ‘%1974%’ OR age LIKE ‘%1975%’ OR age LIKE ‘%1976%’ OR age LIKE ‘%1977%’ OR age LIKE ‘%1978%’ OR age LIKE ‘%1979%’ OR age LIKE ‘%1980%’ OR age LIKE ‘%1981%’ OR age LIKE ‘%1982%’ OR age LIKE ‘%1983%’ OR age LIKE ‘%1984%’ OR age LIKE ‘%1985%’ OR age LIKE ‘%1986%’ OR age LIKE ‘%1987%’ OR age LIKE ‘%1988%’ OR age LIKE ‘%1989%’ OR age LIKE ‘%1990%’ OR age LIKE ‘%1991%’ OR age LIKE ‘%1992%’ OR age LIKE ‘%1993%’ OR age LIKE ‘%1994%’ OR age LIKE ‘%1995%’ OR age LIKE ‘%1996%’ OR age LIKE ‘%1997%’ OR age LIKE ‘%1998%’ OR age LIKE ‘%1999%’ OR age LIKE ‘%2000%’ OR age LIKE ‘%2001%’ OR age LIKE ‘%2002%’ OR age LIKE ‘%2003%’ OR age LIKE ‘%2004%’ OR age LIKE ‘%2005%’ OR age LIKE ‘%2006%’ OR age LIKE ‘%2007%’ OR age LIKE ‘%2008%’ ) AND (1=1) )
dodam tylko ze pole age w bazie to datetime, resztę pozostawiam bez komentarza 
Tags: głupota, mysql, postgresql, sql
Leave a Comment
