►
From YouTube: TTEOT Training Video - S1E7 - SQL: Like vs Equal
Description
There is no tutorial that equals this bi-weekly mayhem. And if you enjoy it, be sure to like it too! George will dazzle you with his straight-forward explanation of these two comparison operators. And is there any thing else he might add this week?
Referenced code:
https://wiki.koha-community.org/wiki/SQL_Reports_Library
https://wiki.koha-community.org/wiki/JQuery_Library#Preset_branch_dropdowns_in_reports_to_your_branch
Music: https://www.bensound.com
A
And
in
this
video
today
we're
gonna
talk
some
more
about
sql
and
this
video,
I
don't
think
it'll,
be
as
long
as
the
last
couple,
because
it's
a
really
simple
topic
that
is
incredibly
useful
and
we're
going
to
talk
about
the
difference
between
using
like
versus
equal
and
where
and
and
having
statements
in
in
in
sql.
So
I'm
going
to
share
my
screen.
A
Of
great
stuff
here-
and
you
can
find
these
videos
that
we're
doing
on
the
learn
from
us
page,
along
with
a
lot
of
other
great
resources-
and
if
you
look
over
here
in
the
middle
of
the
screen,
you've
got
the
jump
to
and
you
can
jump
to,
koha
us
videos
and
somewhere
in
the
next
week
or
two.
This
video
will
pop
up
in
there,
but
there's
a
ton
of
useful
stuff
here
and
since
we're
talking
about
sql,
I'm
gonna.
A
There
is
an
sql
reports,
library
there
and
there
are
lots
of
great
reports
here,
and
this
is
a
great
place
to
go
and
get
a
report
that
you
think
will
do
what
you
wanted
to
do
and-
and
that's
usually
where
I
start
making
reports
is
I'll.
Go
here
I'll,
find
a
report,
that's
already
written
and
then
I'll
build
off
of
that
I'll
change
it
or
tweak
it.
Sometimes
I
even
find
that
there's
a
report
here
that
I've
written
that
I've
already
written
myself
that
and
then
I'll
have
to
go
figure
out.
B
And
I
highly
encourage,
if
you
come
up
with
a
great
report,
to
add
it
to
this.
This
library
also
wanted
to
point
out.
You
know
we
talked
briefly
about
this.
There
is
a
section
for
for
tips
and
we
could
certainly
be
adding
to
that
with
some
of
the
the
videos
that
we've
been
talking
about.
We
can
talk
about
some
of
the
the
tips
that
we've
learned.
B
A
And
I've
got
a
few
reports
that
I've
written
out
already,
so
I'm
on
the
koha
us
demo
site,
which
is
mostly
we've
used
for
some
training
in
some
videos.
We've
got
a
few
reports
in
here
and
I
added
a
bunch
the
other
day
that
have
to
do
with
topics
that
we're
covering.
So
this
first
report,
I'm
just
going
to
put
a
oh.
A
A
A
So
it's
a
really
simple
report
and
the
equals
here
means
that
whenever
in
the
data
items
phone
branch
equals
koha
us
that's
where
we
will
have
a
result,
the
thing
about
equals,
though,
is
equals
works
just
fine,
but
you
have
to
have
you
have
to
have
the
what
you're
doing
be
100
perfect?
It's
an
exact
match,
it's
an
exact
match,
so
I've
got
another
one
here
where
I've
got
the
same
report,
but
in
the
code
I've
got
items
home
branch
like
koha
us.
A
A
A
A
B
A
Another
thing
that
you
can
do
is
the
last
time
around
we
talked
about
the
concat
feature,
I'm
just
going
to
put
an
o
in
here
or
a
k
enter
the
first
part
of
the
library
code.
I'm
going
to
put
a
k
there.
I
made
a
mistake.
I
guess
now
report.
Let's
see
what
I
did
wrong
edit,
I
put
a.
I
got
a
comma
where
there
shouldn't
be
a
comma.
So
let's
try
that
one
again,
okay
run
the
report
and
I'm
going
to
do
anything.
B
B
A
A
I
have
a
report
that
I
use
a
lot
or
that
I
have
libraries
using
a
lot
for
weeding
where
they
want
to
weed
by
call
number,
and
so
my
my
where
statement
is,
where
item
call
number
and
then
enter
the
first
part
of
the
call
number.
So
if
they
want
to
do
a
reading
report
for
large
print,
all
they
have
to
do
is
type
lp
and
it's
going
to
get
them
anything
with
the
call
number
that
starts
with
lp
nice.
A
A
Yes,
if
you
were
to
do
equals
here,
this
would
not
work,
because
it's
going
to
look
for
it's
going
to
actually.
Instead
look
instead
of
considering
that
percent
symbol
as
a
wild
card,
it's
going
to
consider
it's
going
to
look
for
the
percent
symbol
as
actual
text
in
the
title
or
the
or
the
home
branch
name.
A
A
I've
got
items
home
branch
equals
and
the
way
that
you
get
that
drop
down
is
I've
got
enter
library
code
and
then
I
put
this
pipe
here
and
then
there
are
certain
keywords
that
you
can
use
after
a
pipe
to
generate
a
drop
down.
That's
based
off
of
the
what
that,
what
that
keyword
does
and,
of
course
there
is
a
list
of
what
those
keywords
are
in
the
tips
section
of
the
coha
sql
library,
so
branches.
What
it'll
do
is
it'll
create
a
drop
down.
That's
got
a
list
of
all
of
the
branches.
B
A
A
B
A
B
Well,
there's
one
step
further,
I
mean
it's
beyond
this
video,
but
there's
one
step
further.
I
have
a
jquery
that
I
stick
in
for
my
reports,
not
in
the
report
itself,
but
I
have
a
jquery
that
will
default
drop
downs
to
your
branch
to
your
branch.
Yeah,
that's
cool,
so
because
we
use
that
we
use
a
a
custom
made.
B
A
That
that's
a
bad
idea
now
the
important
part
here
is,
you
know
I
just
changed
that
like
to
an
equals.
This
is
what
happens
if
you
forget
to
change
the
equal
sign
to
a
like.
If
you
run
it
with
all
it's
not
going
to
work,
the
other
parts
will
work
right.
The
other
parts
will
work
because
they're
doing
equal
coha
us.
A
A
A
A
A
A
All
50.
I've
got
57
different
lines
in
here
that
I
added
myself
to
its
own
authorized
values
table
and
the
first
one
is
in
all
libraries
drop
down,
but
I
have
four
libraries
in
donovan
county
and
elwood
highland,
troy
and
latina,
and
they
all
start
with
don.
I
so
I've
got
a
an
option
in
this.
If
I
use
this
drop
down
called
donovan
county
library,
all.
A
A
A
A
I
haven't
finished
that
project
yet,
but
this
way
you
know
I
can.
I
can
I'm
working
towards
a
point
where
a
library
can
say
show
me
all
the
adults
and
all
those
five
different
adult
categories,
we'll
count
up
at
once
and
then
show
me
another
report
that'll
show
just
minors
and
and
and
so
on,
I'm
working
that
direction
with
a
couple
of
different
things.
I'm
doing
being
able
to
do.
A
This
makes
the
reports
a
lot
easier
to
use
and
the
way
that
you
do
it
is
you
just
create
an
authorized
values
table
that
has
some
wild
cards
in
it
and
then
you
can
call
it
like
any
other
one
of
those
with
a
with
a
pipe
and
pipe
referencing.
The
the
the
keyword
the
table
that
you
want
to
pull
the
one
that
I
didn't
get
to
their
number.
A
Seven
has
the
same
drop
down,
but
I
use
a
different
authorized
values
table
for
that,
because
I
have
the
same
situation
that
I
complained
to
nick
about
this.
One
has
the
like
donovan
county
and
like
prairie
hills,
but
it
doesn't
have
the
all
libraries,
because
some
of
those
reports,
like
I
said,
if
you
run
for
all
libraries,
so
I've
got
zbrad
and
l
brand-
are
the
ones
that
that
call
the
branches
table
from
the
authorized
values.
Of
course,
the
problem
with
this
is
when
we
have
whenever
we
add
something
new.
A
B
A
B
What
I
think,
oh
you
know,
we
we
have
the
community,
so
we
get
some
good
turnaround
with
with
great
ideas,
but
we
also
have
the
ability
to
work
around
things
and
make
the
system
work
even
better,
with
jquery
and
different
hacks
and
sql
reports
with
authorized
values
and
whatnot.
So
thank
you
for
sharing
that
appreciate
it
and
thank
you
everybody
for
watching,
and
we
will
see
you
again
in
a
couple
weeks
see
you
all
later.