Jezik SQL podpira številne uporabne operaterje, specifične za delo z besedilnimi podatki, kot so na primer primerjava nizov in ujemanje vzorcev z nadomestnimi znaki. Tabela prikazuje nekaj najpogostejših operaterjev za besedilne podatke:
Operator | Pogoj | Primer |
---|---|---|
= | enakost nizov, loči med velikimi in malimi črkami | ime_stolpca = 'abc' |
!= ali <> | neenakost nizov, loči med velikimi in malimi črkami | ime_stolpca != 'abcd' |
LIKE |
enakost nizov, ne loči med velikimi in malimi črkami | ime_stolpca LIKE 'ABC' |
NOT LIKE |
neenakost nizov, ne loči med velikimi in malimi črkami | ime_stolpca NOT LIKE 'ABCD' |
% | kjerkoli v nizu za ujemanje z zaporedjem nič ali več znakov (samo z LIKE ali NOT LIKE ) |
ime_stolpca LIKE '%ot%'(se ujema z nizi 'otok', 'pot', 'potok' idr.) |
_ (podčrtaj) | kjerkoli v nizu za ujemanje z natanko enim znakom (samo z LIKE ali NOT LIKE ) |
ime_stolpca LIKE "po_"(se ujema z nizi 'pot', 'pok' in 'pol'; ne pa s 'po' ali 'polje') |
IN (...) |
besedilo je na seznamu vrednosti | ime_stolpca IN ('A', 'B', 'C') |
NOT IN (...) |
besedila ni na seznamu vrednosti | ime_stolpca NOT IN ('D', 'E') |
Čeprav je večina implementacij podatkov baz precej učinkovita pri uporabi operaterjev za delo z besedilnimi podatki, je iskanje po celotnem besedilu najbolje prepustiti namenskim knjižnicam, kot sta na primer Apache Lucene ali Sphinx. Te knjižnice so zasnovane posebej za iskanje po celotnem besedilu, posledično pa so učinkovitejše in lahko podpirajo več različnih funkcij iskanja, vključno z internacionalizacijo in naprednimi poizvedbami.
id | naslov | reziser | studio_id | leto | dolzina | ocena |
---|---|---|---|---|---|---|
1 | The Little Mermaid | Ron Clements | Disney | 1989 | 83 | 7.6 |
2 | Beauty and the Beast | Gary Trousdale | Disney | 1991 | 84 | 8 |
3 | Aladdin | Ron Clements | Disney | 1992 | 90 | 8 |
4 | The Lion King | Roger Allers | Disney | 1994 | 88 | 8.5 |
5 | Toy Story | John Lasseter | Pixar | 1995 | 81 | 8.3 |
6 | Pocahontas | Mike Gabriel | Disney | 1995 | 81 | 6.7 |
7 | The Hunchback of Notre Dame | Kirk Wise | Disney | 1996 | 91 | 6.9 |
8 | Hercules | John Musker | Disney | 1997 | 93 | 7.3 |
9 | A Bug's Life | John Lasseter | Pixar | 1998 | 95 | 7.2 |
10 | Antz | Eric Darnell | DreamWorks | 1998 | 83 | 6.6 |
11 | The Prince of Egypt | Brenda Chapman | DreamWorks | 1998 | 99 | 7.1 |
12 | Mulan | Barry Cook | Disney | 1998 | 88 | 7.6 |
13 | Toy Story 2 | John Lasseter | Pixar | 1999 | 92 | 7.9 |
14 | Tarzan | Chris Buck | Disney | 1999 | 88 | 7.3 |
15 | Chicken Run | Peter Lord | DreamWorks | 2000 | 84 | 7 |
16 | Dinosaur | Ralph Zondag | Disney | 2000 | 82 | 6.5 |
17 | Monsters, Inc. | Pete Docter | Pixar | 2001 | 92 | 8.1 |
18 | Shrek | Andrew Adamson | DreamWorks | 2001 | 90 | 7.9 |
19 | Ice Age | Chris Wedge | Blue Sky | 2002 | 81 | 7.5 |
20 | Spirit: Stallion of the Cimarron | Kelly Asbury | DreamWorks | 2002 | 83 | 7.1 |
21 | Lilo & Stitch | Dean DeBlois | Disney | 2002 | 85 | 7.2 |
22 | Finding Nemo | Andrew Stanton | Pixar | 2003 | 100 | 8.1 |
23 | Sinbad: Legend of the Seven Seas | Patrick Gilmore | DreamWorks | 2003 | 86 | 6.7 |
24 | The Incredibles | Brad Bird | Pixar | 2004 | 115 | 8 |
25 | Shrek 2 | Andrew Adamson | DreamWorks | 2004 | 93 | 7.2 |
26 | Robots | David Lindsay-Abaire | Blue Sky | 2005 | 91 | 6.3 |
27 | Madagascar | Eric Darnell | DreamWorks | 2005 | 86 | 6.9 |
28 | Chicken Little | Mark Dindal | Disney | 2005 | 81 | 5.8 |
29 | Cars | John Lasseter | Pixar | 2006 | 117 | 7.1 |
30 | Ice Age: The Meltdown | Carlos Saldanha | Blue Sky | 2006 | 91 | 6.8 |
31 | Over the Hedge | Karey Kirkpatrick | DreamWorks | 2006 | 83 | 6.7 |
32 | Flushed Away | David Bowers | DreamWorks | 2006 | 85 | 6.6 |
33 | Ratatouille | Brad Bird | Pixar | 2007 | 111 | 8 |
34 | Shrek the Third | Chris Miller | DreamWorks | 2007 | 93 | 6.1 |
35 | Bee Movie | Simon J. Smith | DreamWorks | 2007 | 91 | 6.1 |
36 | Meet the Robinsons | Stephen J. Anderson | Disney | 2007 | 95 | 6.9 |
37 | Wall-E | Andrew Stanton | Pixar | 2008 | 98 | 8.4 |
38 | Dr. Seuss' Horton Hears a Who! | Jimmy Hayward | Blue Sky | 2008 | 86 | 6.8 |
39 | Kung Fu Panda | Mark Osborne | DreamWorks | 2008 | 92 | 7.6 |
40 | Madagascar: Escape 2 Africa | Eric Darnell | DreamWorks | 2008 | 89 | 6.7 |
41 | Monsters vs. Aliens | Rob Letterman | DreamWorks | 2008 | 94 | 6.5 |
42 | Bolt | Chris Williams | Disney | 2008 | 96 | 6.9 |
43 | Up | Pete Docter | Pixar | 2009 | 96 | 8.2 |
44 | Ice Age: Dawn of the Dinosaurs | Carlos Saldanha | Blue Sky | 2009 | 94 | 7 |
45 | The Princess and the Frog | John Musker | Disney | 2009 | 97 | 7.1 |
46 | Toy Story 3 | Lee Unkrich | Pixar | 2010 | 103 | 8.3 |
47 | Despicable Me | Pierre Coffin | Illumination | 2010 | 95 | 7.7 |
48 | How to Train Your Dragon | Dean DeBlois | DreamWorks | 2010 | 98 | 8.1 |
49 | Shrek Forever After | Mike Mitchell | DreamWorks | 2010 | 93 | 6.3 |
50 | Megamind | Tom McGrath | DreamWorks | 2010 | 95 | 7.3 |
51 | Tangled | Nathan Greno | Disney | 2010 | 100 | 7.8 |
52 | Cars 2 | John Lasseter | Pixar | 2011 | 106 | 6.2 |
53 | Rio | Carlos Saldanha | Blue Sky | 2011 | 96 | 6.9 |
54 | Kung Fu Panda 2 | Jennifer Yuh Nelson | DreamWorks | 2011 | 90 | 7.2 |
55 | Puss in Boots | Chris Miller | DreamWorks | 2011 | 90 | 6.6 |
56 | Brave | Brenda Chapman | Pixar | 2012 | 93 | 7.1 |
57 | Dr. Seuss' The Lorax | Chris Renaud | Illumination | 2012 | 86 | 6.4 |
58 | Ice Age: Continental Drift | Steve Martino | Blue Sky | 2012 | 88 | 6.6 |
59 | Madagascar 3: Europe's Most Wanted | Eric Darnell | DreamWorks | 2012 | 93 | 6.8 |
60 | Rise of the Guardians | Peter Ramsey | DreamWorks | 2012 | 97 | 7.3 |
61 | Wreck-It Ralph | Rich Moore | Disney | 2012 | 101 | 7.7 |
62 | Monsters University | Dan Scanlon | Pixar | 2013 | 104 | 7.3 |
63 | Despicable Me 2 | Pierre Coffin | Illumination | 2013 | 98 | 7.4 |
64 | Epic | Chris Wedge | Blue Sky | 2013 | 102 | 6.7 |
65 | The Croods | Kirk DeMicco | DreamWorks | 2013 | 98 | 7.2 |
66 | Turbo | David Soren | DreamWorks | 2013 | 96 | 6.4 |
67 | Frozen | Chris Buck | Disney | 2013 | 102 | 7.5 |
68 | Rio 2 | Carlos Saldanha | Blue Sky | 2014 | 101 | 6.3 |
69 | Mr. Peabody & Sherman | Rob Minkoff | DreamWorks | 2014 | 92 | 6.8 |
70 | How to Train Your Dragon 2 | Dean DeBlois | DreamWorks | 2014 | 102 | 7.8 |
71 | Penguins of Madagascar | Eric Darnell | DreamWorks | 2014 | 92 | 6.7 |
72 | Big Hero 6 | Don Hall | Disney | 2014 | 102 | 7.8 |
73 | Inside Out | Pete Docter | Pixar | 2015 | 95 | 8.2 |
74 | The Good Dinosaur | Peter Sohn | Pixar | 2015 | 93 | 6.7 |
75 | Minions | Pierre Coffin | Illumination | 2015 | 91 | 6.4 |
76 | The Peanuts Movie | Steve Martino | Blue Sky | 2015 | 88 | 7.1 |
77 | Home | Tim Johnson | DreamWorks | 2015 | 94 | 6.6 |
78 | Finding Dory | Andrew Stanton | Pixar | 2016 | 97 | 7.3 |
79 | The Secret Life of Pets | Chris Renaud | Illumination | 2016 | 87 | 6.5 |
80 | Sing | Garth Jennings | Illumination | 2016 | 108 | 7.1 |
81 | Ice Age: Collision Course | Mike Thurmeier | Blue Sky | 2016 | 94 | 5.7 |
82 | Kung Fu Panda 3 | Alessandro Carloni | DreamWorks | 2016 | 95 | 7.1 |
83 | Trolls | Mike Mitchell | DreamWorks | 2016 | 92 | 6.5 |
84 | Zootopia | Byron Howard | Disney | 2016 | 108 | 8 |
85 | Moana | John Musker | Disney | 2016 | 107 | 7.6 |
86 | Cars 3 | Brian Fee | Pixar | 2017 | 102 | 6.8 |
87 | Coco | Lee Unkrich | Pixar | 2017 | 105 | 8.4 |
88 | Despicable Me 3 | Pierre Coffin | Illumination | 2017 | 89 | 6.3 |
89 | Ferdinand | Carlos Saldanha | Blue Sky | 2017 | 108 | 6.7 |
90 | The Boss Baby | Tom McGrath | DreamWorks | 2017 | 97 | 6.3 |
91 | Captain Underpants: The First Epic Movie | David Soren | DreamWorks | 2017 | 89 | 6.2 |
92 | Incredibles 2 | Brad Bird | Pixar | 2018 | 118 | 7.7 |
93 | Dr. Seuss' The Grinch | Scott Mosier | Illumination | 2018 | 86 | 6.3 |
94 | Ralph Breaks the Internet | Rich Moore | Disney | 2018 | 112 | 7.1 |
95 | How to Train Your Dragon: The Hidden World | Dean DeBlois | DreamWorks | 2019 | 104 | 7.7 |
96 | The Secret Life of Pets 2 | Chris Renaud | Illumination | 2019 | 86 | 6.5 |
97 | Toy Story 4 | Josh Cooley | Pixar | 2019 | 100 | 7.8 |
98 | Abominable | Jill Culton | DreamWorks | 2019 | 97 | 7 |
99 | Frozen II | Chris Buck | Disney | 2019 | 103 | 6.9 |
100 | Spies in Disguise | Nick Bruno | Blue Sky | 2019 | 102 | 6.8 |
101 | Onward | Dan Scanlon | Pixar | 2020 | 102 | 7.4 |
102 | Trolls 2: World Tour | Walt Dohrn | DreamWorks | 2020 | 90 | 6.1 |
103 | The Croods: A New Age | Joel Crawford | DreamWorks | 2020 | 95 | 7 |
104 | Soul | Pete Docter | Pixar | 2020 | 100 | 8.1 |
105 | Raya and the Last Dragon | Don Hall | Disney | 2021 | 107 | 7.5 |
106 | Spirit Untamed | Elaine Bogan | DreamWorks | 2021 | 88 | 5.5 |
107 | Luca | Enrico Casarosa | Pixar | 2021 | 95 | 7.4 |
108 | The Boss Baby 2: Family Busines | Tom McGrath | DreamWorks | 2021 | 107 | 5.8 |
109 | Encanto | Byron Howard | Disney | 2021 | 102 | 7.2 |
110 | Sing 2 | Garth Jennings | Illumination | 2021 | 110 | 7.4 |